Skip Headers

Oracle® Database PL/SQL User's Guide and Reference 10g Release 2 (10.2) Part Number B14261-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# D PL/SQL Reserved Words and Keywords

The words listed in this appendix are reserved by PL/SQL. You should not use them to name program objects such as constants, variables, cursors, schema objects such as columns, tables, or indexes.

These words reserved by PL/SQL are classified as keywords or reserved words. See Table D-1 and Table D-2. Reserved words can never be used as identifiers. Keywords can be used as identifiers, but this is not recommended.

Some of these words are also reserved by SQL. For a list of the Oracle database reserved words, see Oracle Database SQL Reference. You can generate a list of all keywords and reserved words with the `V$RESERVED_WORDS` view, described in Oracle Database Reference.

Table D-1 lists the PL/SQL reserved words.

Table D-1 PL/SQL Reserved Words

Begins with: | Reserved Words
--- | ---
A | ALL, ALTER, AND, ANY, ARRAY, ARROW, AS, ASC, AT
B | BEGIN, BETWEEN, BY
C | CASE, CHECK, CLUSTERS, CLUSTER, COLAUTH, COLUMNS, COMPRESS, CONNECT, CRASH, CREATE, CURRENT
D | DECIMAL, DECLARE, DEFAULT, DELETE, DESC, DISTINCT, DROP
E | ELSE, END, EXCEPTION, EXCLUSIVE, EXISTS
F | FETCH, FORM, FOR, FROM
G | GOTO, GRANT, GROUP
H | HAVING
I | IDENTIFIED, IF, IN, INDEXES, INDEX, INSERT, INTERSECT, INTO, IS
L | LIKE, LOCK
M | MINUS, MODE
N | NOCOMPRESS, NOT, NOWAIT, NULL
O | OF, ON, OPTION, OR, ORDER,OVERLAPS
P | PRIOR, PROCEDURE, PUBLIC
R | RANGE, RECORD, RESOURCE, REVOKE
S | SELECT, SHARE, SIZE, SQL, START, SUBTYPE
T | TABAUTH, TABLE, THEN, TO, TYPE
U | UNION, UNIQUE, UPDATE, USE
V | VALUES, VIEW, VIEWS
W | WHEN, WHERE, WITH

Table D-2 lists the PL/SQL keywords.

Table D-2 PL/SQL Keywords

Begins with: | Keywords
--- | ---
A | A, ADD, AGENT, AGGREGATE, ARRAY, ATTRIBUTE, AUTHID, AVG
B | BFILE_BASE, BINARY, BLOB_BASE, BLOCK, BODY, BOTH, BOUND, BULK, BYTE
C | C, CALL, CALLING, CASCADE, CHAR, CHAR_BASE, CHARACTER, CHARSETFORM, CHARSETID, CHARSET, CLOB_BASE, CLOSE, COLLECT, COMMENT, COMMIT, COMMITTED, COMPILED, CONSTANT, CONSTRUCTOR, CONTEXT, CONVERT, COUNT, CURSOR, CUSTOMDATUM
D | DANGLING, DATA, DATE, DATE_BASE, DAY, DEFINE, DETERMINISTIC, DOUBLE, DURATION
E | ELEMENT, ELSIF, EMPTY, ESCAPE, EXCEPT, EXCEPTIONS, EXECUTE, EXIT, EXTERNAL
F | FINAL, FIXED, FLOAT, FORALL, FORCE, FUNCTION
G | GENERAL
H | HASH, HEAP, HIDDEN, HOUR
I | IMMEDIATE, INCLUDING, INDICATOR, INDICES, INFINITE, INSTANTIABLE, INT, INTERFACE, INTERVAL, INVALIDATE, ISOLATION
J | JAVA
L | LANGUAGE, LARGE, LEADING, LENGTH, LEVEL, LIBRARY, LIKE2, LIKE4, LIKEC, LIMIT, LIMITED, LOCAL, LONG, LOOP
M | MAP, MAX, MAXLEN, MEMBER, MERGE, MIN, MINUTE, MOD, MODIFY, MONTH, MULTISET
N | NAME, NAN, NATIONAL, NATIVE, NCHAR, NEW, NOCOPY, NUMBER_BASE
O | OBJECT, OCICOLL, OCIDATETIME, OCIDATE, OCIDURATION, OCIINTERVAL, OCILOBLOCATOR, OCINUMBER, OCIRAW, OCIREFCURSOR, OCIREF, OCIROWID, OCISTRING, OCITYPE, ONLY, OPAQUE, OPEN, OPERATOR, ORACLE, ORADATA, ORGANIZATION, ORLANY, ORLVARY, OTHERS, OUT, OVERRIDING
P | PACKAGE, PARALLEL_ENABLE, PARAMETER, PARAMETERS, PARTITION, PASCAL, PIPE, PIPELINED, PRAGMA, PRECISION, PRIVATE
R | RAISE, RANGE, RAW, READ, RECORD, REF, REFERENCE, REM, REMAINDER, RENAME, RESULT, RETURN, RETURNING, REVERSE, ROLLBACK, ROW
S | SAMPLE, SAVE, SAVEPOINT, SB1, SB2, SB4, SECOND, SEGMENT, SELF, SEPARATE, SEQUENCE, SERIALIZABLE, SET, SHORT, SIZE_T, SOME, SPARSE, SQLCODE, SQLDATA, SQLNAME, SQLSTATE, STANDARD, STATIC, STDDEV, STORED, STRING, STRUCT, STYLE, SUBMULTISET, SUBPARTITION, SUBSTITUTABLE, SUBTYPE, SUM, SYNONYM
T | TDO, THE, TIME, TIMESTAMP, TIMEZONE_ABBR, TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TRAILING, TRANSAC, TRANSACTIONAL, TRUSTED, TYPE
U | UB1, UB2, UB4, UNDER, UNSIGNED, UNTRUSTED, USE, USING
V | VALIST, VALUE, VARIABLE, VARIANCE, VARRAY, VARYING, VOID
W | WHILE, WORK, WRAPPED, WRITE
Y | YEAR
Z | ZONE